{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Generator","Armies","Units","Comments"],"not_rendered":{"macros":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Generator","index":0,"n_rows":49,"n_cols":15,"rows_kept":49,"merged":[[0,0,0,14],[1,4,1,6],[1,9,1,11],[2,4,2,6],[2,9,2,11],[8,1,8,6],[8,9,8,13],[9,8,14,8],[13,1,13,2],[13,3,13,4],[13,5,13,6],[14,1,14,6],[14,10,14,12],[16,8,21,8],[20,1,20,2],[20,3,20,4],[20,5,20,6],[21,1,21,6],[21,10,21,12],[23,1,23,2],[23,3,23,4],[23,5,23,6],[23,8,23,9],[23,10,23,11],[23,12,23,13],[24,1,47,1],[24,2,31,2],[24,3,24,4],[24,5,24,6],[24,8,47,8],[24,9,31,9],[24,10,24,11],[24,12,24,13],[25,3,25,4],[25,5,25,6],[25,10,25,11],[25,12,25,13],[26,3,26,4],[26,5,26,6],[26,10,26,11],[26,12,26,13],[27,3,27,4],[27,5,27,6],[27,10,27,11],[27,12,27,13],[28,3,28,4],[28,5,28,6],[28,10,28,11],[28,12,28,13],[29,3,29,4],[29,5,29,6],[29,10,29,11],[29,12,29,13],[30,3,30,4],[30,5,30,6],[30,10,30,11],[30,12,30,13],[31,3,31,4],[31,5,31,6],[31,10,31,11],[31,12,31,13],[32,2,39,2],[32,3,32,4],[32,5,32,6],[32,9,39,9],[32,10,32,11],[32,12,32,13],[33,3,33,4],[33,5,33,6],[33,10,33,11],[33,12,33,13],[34,3,34,4],[34,5,34,6],[34,10,34,11],[34,12,34,13],[35,3,35,4],[35,5,35,6],[35,10,35,11],[35,12,35,13],[36,3,36,4],[36,5,36,6],[36,10,36,11],[36,12,36,13],[37,3,37,4],[37,5,37,6],[37,10,37,11],[37,12,37,13],[38,3,38,4],[38,5,38,6],[38,10,38,11],[38,12,38,13],[39,3,39,4],[39,5,39,6],[39,10,39,11],[39,12,39,13],[40,2,47,2],[40,3,40,4],[40,5,40,6],[40,9,47,9],[40,10,40,11],[40,12,40,13],[41,3,41,4],[41,5,41,6],[41,10,41,11],[41,12,41,13],[42,3,42,4],[42,5,42,6],[42,10,42,11],[42,12,42,13],[43,3,43,4],[43,5,43,6],[43,10,43,11],[43,12,43,13],[44,3,44,4],[44,5,44,6],[44,10,44,11],[44,12,44,13],[45,3,45,4],[45,5,45,6],[45,10,45,11],[45,12,45,13],[46,3,46,4],[46,5,46,6],[46,10,46,11],[46,12,46,13],[47,3,47,4],[47,5,47,6],[47,10,47,11],[47,12,47,13],[48,1,48,6],[48,8,48,13]]}
["Select your armies, then press \"Generate Armies Now\". "]
[{"$nulls":4},"Army",{"$nulls":4},"Army"]
[{"$nulls":3},"1st army : ","French",{"$nulls":3},"2nd army : ","British"]
[]
[]
[]
[]
[]
["Nat","Number of units in each groups",{"$nulls":7},"Number of units in each wings"]
[{"$f":"DGET(Comments!$A$2:$B$8,Comments!$B$2,Generator!$E$2:$E$3)","v":"Fr"},"G1","G2","G3","G4","G5","G6",null,"2 wings : Groups 1 to 4\n3 wings : Groups 1 to 6","2 wings","Wing  1","Wing 2","Wing 3","3 wings"]
["Inf",{"$f":"Armies!M22","v":3},{"$f":"Armies!N22","v":3},{"$f":"Armies!O22","v":2},{"$f":"Armies!P22","v":2},{"$f":"Armies!Q22","v":4},{"$f":"Armies!R22","v":2},null,null,{"$f":"SUM(K11:L11)","v":10},{"$f":"SUM(B11:C11)","v":6},{"$f":"SUM(D11:E11)","v":4},{"$f":"SUM(F11:G11)","v":6},{"$f":"SUM(K11:M11)","v":16},"Inf"]
["Cav",{"$f":"Armies!M24","v":2},{"$f":"Armies!N24","v":2},{"$f":"Armies!O24","v":3},{"$f":"Armies!P24","v":1},{"$f":"Armies!Q24","v":3},{"$f":"Armies!R24","v":1},null,null,{"$f":"SUM(K12:L12)","v":8},{"$f":"SUM(B12:C12)","v":4},{"$f":"SUM(D12:E12)","v":4},{"$f":"SUM(F12:G12)","v":4},{"$f":"SUM(K12:M12)","v":12},"Cav"]
["Art",{"$f":"Armies!M26","v":1},{"$f":"Armies!N26","v":1},{"$f":"Armies!O26","v":1},{"$f":"Armies!P26","v":0},{"$f":"Armies!Q26","v":1},{"$f":"Armies!R26","v":1},null,null,{"$f":"SUM(K13:L13)","v":3},{"$f":"SUM(B13:C13)","v":2},{"$f":"SUM(D13:E13)","v":1},{"$f":"SUM(F13:G13)","v":2},{"$f":"SUM(K13:M13)","v":5},"Art"]
["Gal",{"$f":"\"General (\"&Armies!M21&\")\"","v":"General (0)"},null,{"$f":"\"General (\"&Armies!O21&\")\"","v":"General (0)"},null,{"$f":"\"General (\"&Armies!Q21&\")\"","v":"General (0)"},{"$nulls":4},{"$f":"B14","v":"General (0)"},{"$f":"D14","v":"General (0)"},{"$f":"F14","v":"General (0)"},null,"Gal"]
["Gal",{"$f":"\"Army General (\"&Armies!M20&\")\"","v":"Army General (0)"},{"$nulls":8},{"$f":"B15","v":"Army General (0)"},{"$nulls":3},"Gal"]
["Nat"]
[{"$f":"DGET(Comments!$A$2:$B$8,Comments!$B$2,Generator!$J$2:$J$3)","v":"GB"},"G1","G2","G3","G4","G5","G6",null,"2 wings : Groups 1 to 4\n3 wings : Groups 1 to 6","2 wings","Wing  1","Wing 2","Wing 3","3 wings"]
["Inf",{"$f":"Armies!M28","v":1},{"$f":"Armies!N28","v":3},{"$f":"Armies!O28","v":3},{"$f":"Armies!P28","v":3},{"$f":"Armies!Q28","v":3},{"$f":"Armies!R28","v":3},null,null,{"$f":"SUM(K18:L18)","v":10},{"$f":"SUM(B18:C18)","v":4},{"$f":"SUM(D18:E18)","v":6},{"$f":"SUM(F18:G18)","v":6},{"$f":"SUM(K18:M18)","v":16},"Inf"]
["Cav",{"$f":"Armies!M30","v":2},{"$f":"Armies!N30","v":1},{"$f":"Armies!O30","v":1},{"$f":"Armies!P30","v":2},{"$f":"Armies!Q30","v":2},{"$f":"Armies!R30","v":2},null,null,{"$f":"SUM(K19:L19)","v":6},{"$f":"SUM(B19:C19)","v":3},{"$f":"SUM(D19:E19)","v":3},{"$f":"SUM(F19:G19)","v":4},{"$f":"SUM(K19:M19)","v":10},"Cav"]
["Art",{"$f":"Armies!M32","v":1},{"$f":"Armies!N32","v":0},{"$f":"Armies!O32","v":1},{"$f":"Armies!P32","v":0},{"$f":"Armies!Q32","v":1},{"$f":"Armies!R32","v":1},null,null,{"$f":"SUM(K20:L20)","v":2},{"$f":"SUM(B20:C20)","v":1},{"$f":"SUM(D20:E20)","v":1},{"$f":"SUM(F20:G20)","v":2},{"$f":"SUM(K20:M20)","v":4},"Art"]
["Gal",{"$f":"\"General (\"&Armies!M33&\")\"","v":"General (2)"},null,{"$f":"\"General (\"&Armies!O33&\")\"","v":"General (1)"},null,{"$f":"\"General (\"&Armies!Q33&\")\"","v":"General (1)"},{"$nulls":4},{"$f":"B21","v":"General (2)"},{"$f":"D21","v":"General (1)"},{"$f":"F21","v":"General (1)"},null,"Gal"]
["Gal",{"$f":"\"Army General (\"&Armies!M34&\")\"","v":"Army General (2)"},{"$nulls":8},{"$f":"B22","v":"Army General (2)"},{"$nulls":3},"Gal"]
[null,"Nat",{"$nulls":6},"Nat"]
[null,{"$f":"$E$3","v":"French"},null,"Inf",null,"Cav",null,null,{"$f":"$J$3","v":"British"},null,"Inf",null,"Cav"]
[null,{"$f":"K15","v":"Army General (0)"},{"$f":"K14&CHAR(10)&CHAR(10)&K13&\" art.\"","v":"General (0)\n\n2 art."},{"$f":"IF($H25>K$11,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!D$24,Units!B13:B14))","v":"German"},null,{"$f":"IF($H25>K$12,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!F$24,Units!C13:C14))","v":"Hussars***"},null,1,{"$f":"K22","v":"Army General (2)"},{"$f":"K21&CHAR(10)&CHAR(10)&K20&\" art.\"","v":"General (2)\n\n1 art."},{"$f":"IF($H25>K$18,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!K$24,Units!D13:D14))","v":"Hessian Line*"},null,{"$f":"IF($H25>K$19,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!M$24,Units!D13:D14))","v":"German Dragoons"}]
[{"$nulls":3},{"$f":"IF($H26>K$11,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!D$24,Units!B15:B16))","v":"Vieux"},null,{"$f":"IF($H26>K$12,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!F$24,Units!C15:C16))","v":"Cavalerie légère"},null,2,null,null,{"$f":"IF($H26>K$18,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!K$24,Units!D15:D16))","v":"Hessian Line*"},null,{"$f":"IF($H26>K$19,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!M$24,Units!D15:D16))","v":"German Dragoons"}]
[{"$nulls":3},{"$f":"IF($H27>K$11,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!D$24,Units!B17:B18))","v":"Line"},null,{"$f":"IF($H27>K$12,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!F$24,Units!C17:C18))","v":"Cavalerie légère"},null,3,null,null,{"$f":"IF($H27>K$18,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!K$24,Units!D17:D18))","v":"Hanoverian Line"},null,{"$f":"IF($H27>K$19,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!M$24,Units!D17:D18))","v":"German Dragoons"}]
[{"$nulls":3},{"$f":"IF($H28>K$11,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!D$24,Units!B19:B20))","v":"Swiss"},null,{"$f":"IF($H28>K$12,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!F$24,Units!C19:C20))","v":"Elite"},null,4,null,null,{"$f":"IF($H28>K$18,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!K$24,Units!D19:D20))","v":"Hessian Line*"},null,{"$f":"IF($H28>K$19,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!M$24,Units!D19:D20))","v":""}]
[{"$nulls":3},{"$f":"IF($H29>K$11,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!D$24,Units!B21:B22))","v":"German"},null,{"$f":"IF($H29>K$12,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!F$24,Units!C21:C22))","v":""},null,5,null,null,{"$f":"IF($H29>K$18,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!K$24,Units!D21:D22))","v":""},null,{"$f":"IF($H29>K$19,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!M$24,Units!D21:D22))","v":""}]
[{"$nulls":3},{"$f":"IF($H30>K$11,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!D$24,Units!B23:B24))","v":"Swiss"},null,{"$f":"IF($H30>K$12,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!F$24,Units!C23:C24))","v":""},null,6,null,null,{"$f":"IF($H30>K$18,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!K$24,Units!D23:D24))","v":""},null,{"$f":"IF($H30>K$19,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!M$24,Units!D23:D24))","v":""}]
[{"$nulls":3},{"$f":"IF($H31>K$11,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!D$24,Units!B25:B26))","v":""},null,{"$f":"IF($H31>K$12,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!F$24,Units!C25:C26))","v":""},null,7,null,null,{"$f":"IF($H31>K$18,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!K$24,Units!D25:D26))","v":""},null,{"$f":"IF($H31>K$19,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!M$24,Units!D25:D26))","v":""}]
[{"$nulls":3},{"$f":"IF($H32>K$11,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!D$24,Units!B27:B28))","v":""},null,{"$f":"IF($H32>K$12,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!F$24,Units!C27:C28))","v":""},null,8,null,null,{"$f":"IF($H32>K$18,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!K$24,Units!D27:D28))","v":""},null,{"$f":"IF($H32>K$19,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!M$24,Units!D27:D28))","v":""}]
[null,null,{"$f":"L14&CHAR(10)&CHAR(10)&L13&\" art.\"","v":"General (0)\n\n1 art."},{"$f":"IF($H33>L$11+8,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!D$24,Units!B29:B30))","v":"Line"},null,{"$f":"IF($H33>L$12+8,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!F$24,Units!C29:C30))","v":"Dragoons"},null,9,null,{"$f":"L21&CHAR(10)&CHAR(10)&L20&\" art.\"","v":"General (1)\n\n1 art."},{"$f":"IF($H33>L$18+8,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!K$24,Units!D29:D30))","v":"Hanoverian Line"},null,{"$f":"IF($H33>L$19+8,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!M$24,Units!D29:D30))","v":"German Horse"}]
[{"$nulls":3},{"$f":"IF($H34>L$11+8,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!D$24,Units!B31:B32))","v":"Line"},null,{"$f":"IF($H34>L$12+8,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!F$24,Units!C31:C32))","v":"Cavalerie légère"},null,10,null,null,{"$f":"IF($H34>L$18+8,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!K$24,Units!D31:D32))","v":"Hanoverian Line"},null,{"$f":"IF($H34>L$19+8,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!M$24,Units!D31:D32))","v":"German Dragoons"}]
[{"$nulls":3},{"$f":"IF($H35>L$11+8,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!D$24,Units!B33:B34))","v":"Line"},null,{"$f":"IF($H35>L$12+8,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!F$24,Units!C33:C34))","v":"Cavalerie légère"},null,11,null,null,{"$f":"IF($H35>L$18+8,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!K$24,Units!D33:D34))","v":"Grenadiers**"},null,{"$f":"IF($H35>L$19+8,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!M$24,Units!D33:D34))","v":"British Horse/Dragoon Guard"}]
[{"$nulls":3},{"$f":"IF($H36>L$11+8,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!D$24,Units!B35:B36))","v":"Grenadiers*"},null,{"$f":"IF($H36>L$12+8,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!F$24,Units!C35:C36))","v":"Cavalerie légère"},null,12,null,null,{"$f":"IF($H36>L$18+8,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!K$24,Units!D35:D36))","v":"Hessian Line*"},null,{"$f":"IF($H36>L$19+8,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!M$24,Units!D35:D36))","v":""}]
[{"$nulls":3},{"$f":"IF($H37>L$11+8,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!D$24,Units!B37:B38))","v":""},null,{"$f":"IF($H37>L$12+8,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!F$24,Units!C37:C38))","v":""},null,13,null,null,{"$f":"IF($H37>L$18+8,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!K$24,Units!D37:D38))","v":"Hanoverian Line"},null,{"$f":"IF($H37>L$19+8,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!M$24,Units!D37:D38))","v":""}]
[{"$nulls":3},{"$f":"IF($H38>L$11+8,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!D$24,Units!B39:B40))","v":""},null,{"$f":"IF($H38>L$12+8,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!F$24,Units!C39:C40))","v":""},null,14,null,null,{"$f":"IF($H38>L$18+8,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!K$24,Units!D39:D40))","v":"Grenadiers**"},null,{"$f":"IF($H38>L$19+8,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!M$24,Units!D39:D40))","v":""}]
[{"$nulls":3},{"$f":"IF($H39>L$11+8,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!D$24,Units!B41:B42))","v":""},null,{"$f":"IF($H39>L$12+8,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!F$24,Units!C41:C42))","v":""},null,15,null,null,{"$f":"IF($H39>L$18+8,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!K$24,Units!D41:D42))","v":""},null,{"$f":"IF($H39>L$19+8,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!M$24,Units!D41:D42))","v":""}]
[{"$nulls":3},{"$f":"IF($H40>L$11+8,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!D$24,Units!B43:B44))","v":""},null,{"$f":"IF($H40>L$12+8,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!F$24,Units!C43:C44))","v":""},null,16,null,null,{"$f":"IF($H40>L$18+8,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!K$24,Units!D43:D44))","v":""},null,{"$f":"IF($H40>L$19+8,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!M$24,Units!D43:D44))","v":""}]
[null,null,{"$f":"M14&CHAR(10)&CHAR(10)&M13&\" art.\"","v":"General (0)\n\n2 art."},{"$f":"IF($H41>M$11+16,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!D$24,Units!B45:B46))","v":"German"},null,{"$f":"IF($H41>M$12+16,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!F$24,Units!C45:C46))","v":"Dragoons"},null,17,null,{"$f":"M21&CHAR(10)&CHAR(10)&M20&\" art.\"","v":"General (1)\n\n2 art."},{"$f":"IF($H41>M$18+16,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!K$24,Units!D45:D46))","v":"Brunswick Line*"},null,{"$f":"IF($H41>M$19+16,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!M$24,Units!D45:D46))","v":"Prussian Dragoons"}]
[{"$nulls":3},{"$f":"IF($H42>M$11+16,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!D$24,Units!B47:B48))","v":"Saxon**"},null,{"$f":"IF($H42>M$12+16,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!F$24,Units!C47:C48))","v":"Cavalerie légère"},null,18,null,null,{"$f":"IF($H42>M$18+16,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!K$24,Units!D47:D48))","v":"Hessian Line*"},null,{"$f":"IF($H42>M$19+16,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!M$24,Units!D47:D48))","v":"Guard/Elite***"}]
[{"$nulls":3},{"$f":"IF($H43>M$11+16,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!D$24,Units!B49:B50))","v":"German"},null,{"$f":"IF($H43>M$12+16,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!F$24,Units!C49:C50))","v":"Elite"},null,19,null,null,{"$f":"IF($H43>M$18+16,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!K$24,Units!D49:D50))","v":"Hessian Line*"},null,{"$f":"IF($H43>M$19+16,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!M$24,Units!D49:D50))","v":"Guard/Elite***"}]
[{"$nulls":3},{"$f":"IF($H44>M$11+16,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!D$24,Units!B51:B52))","v":"Line"},null,{"$f":"IF($H44>M$12+16,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!F$24,Units!C51:C52))","v":"Elite"},null,20,null,null,{"$f":"IF($H44>M$18+16,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!K$24,Units!D51:D52))","v":"British Line"},null,{"$f":"IF($H44>M$19+16,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!M$24,Units!D51:D52))","v":"Prussian Dragoons"}]
[{"$nulls":3},{"$f":"IF($H45>M$11+16,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!D$24,Units!B53:B54))","v":"Vieux"},null,{"$f":"IF($H45>M$12+16,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!F$24,Units!C53:C54))","v":""},null,21,null,null,{"$f":"IF($H45>M$18+16,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!K$24,Units!D53:D54))","v":"British Line"},null,{"$f":"IF($H45>M$19+16,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!M$24,Units!D53:D54))","v":""}]
[{"$nulls":3},{"$f":"IF($H46>M$11+16,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!D$24,Units!B55:B56))","v":"German"},null,{"$f":"IF($H46>M$12+16,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!F$24,Units!C55:C56))","v":""},null,22,null,null,{"$f":"IF($H46>M$18+16,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!K$24,Units!D55:D56))","v":"Hessian Line*"},null,{"$f":"IF($H46>M$19+16,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!M$24,Units!D55:D56))","v":""}]
[{"$nulls":3},{"$f":"IF($H47>M$11+16,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!D$24,Units!B57:B58))","v":""},null,{"$f":"IF($H47>M$12+16,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!F$24,Units!C57:C58))","v":""},null,23,null,null,{"$f":"IF($H47>M$18+16,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!K$24,Units!D57:D58))","v":""},null,{"$f":"IF($H47>M$19+16,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!M$24,Units!D57:D58))","v":""}]
[{"$nulls":3},{"$f":"IF($H48>M$11+16,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!D$24,Units!B59:B60))","v":""},null,{"$f":"IF($H48>M$12+16,\"\",DGET(Units!$A$1:$M$11,Generator!$A$10&\"-\"&Generator!F$24,Units!C59:C60))","v":""},null,24,null,null,{"$f":"IF($H48>M$18+16,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!K$24,Units!D59:D60))","v":""},null,{"$f":"IF($H48>M$19+16,\"\",DGET(Units!$A$1:$M$11,Generator!$A$17&\"-\"&Generator!M$24,Units!D59:D60))","v":""}]
[null,{"$f":"DGET(Comments!$B$1:$C$8,\"Comment\",$A$9:$A$10)","v":"* Roll a further D6. On a score of 1 to 3 the unit is Grenadiers de France, on a score of 4 to 6 the unit is Grenadiers Royaux. Only 1 unit of each is allow and so if a 2nd unit is rolled for this will automatically be the other type. If a 3rd unit is rolled for reroll.\n** Every third unit can be an Allied Elite unit.\n*** The first unit rolled for is a Hussar unit. The second unit rolled for is a Mounted Chasseur unit. The third unit is a Guard or Elite unit. If more units are rolled for then start the sequence again, i.e. the 4th unit will be Hussars.\n\nArtillery are always Field Guns"},{"$nulls":6},{"$f":"DGET(Comments!$B$1:$C$8,\"Comment\",$A$16:$A$17)","v":"* Roll a D6 and on a score of 6 the unit has RF.\n** Can be a unit of any nationality or mixed. Only one unit per nationality is allowed.Choose or dice for which based on the rest of the army. Hessian or Brunswick units roll a D6 and on a score of 5 or 6 the unit has RF.\n*** As above with Grenadiers except Hessian or Brunswick units roll a D6 and on a score of 4, 5 or 6 the unit has RF. If a second unit is rolled for the player gets a Jager (for infantry) or Light Cavalry (for cavalry) unit instead. A 3rd or subsequent unit will be Guard or Elite.\n\nArtillery are always Field Guns"}]

{"sheet":"Armies","index":1,"n_rows":34,"n_cols":25,"rows_kept":34,"hidden":true,"merged":[[19,1,19,6],[19,7,19,10],[19,12,19,17],[20,12,20,13],[20,14,20,15],[20,16,20,17],[32,12,32,13],[32,14,32,15],[32,16,32,17],[33,12,33,17]]}
[]
["Dé","Fr-Inf","Fr-Cav","Fr-Art","Fr-Gal","GB-Inf","GB-Cav","GB-Art","GB-Gal","Pr1-Inf","Pr1-Cav","Pr1-Art","Pr1-Gal","Aust-Inf","Aust-Cav","Aust-Art","Aust-Gal","Pr2-Inf","Pr2-Cav","Pr2-Art","Pr2-Gal","Ru-Inf","Ru-Cav","Ru-Art","Ru-Gal"]
[1,2,1,0,0,1,1,0,0,1,1,1,0,2,1,0,0,1,1,1,0,2,1,1,0]
[]
[2,3,2,1,0,2,1,0,1,2,1,1,1,3,1,1,0,2,1,1,1,2,2,1,0]
[]
[3,3,2,1,0,2,2,1,1,2,2,1,1,3,2,1,1,2,2,1,1,3,2,2,0]
[]
[4,3,2,1,0,3,2,1,1,2,2,1,1,4,2,1,1,2,2,1,1,3,2,2,1]
[]
[5,3,3,1,0,3,2,1,1,3,2,1,1,4,2,2,1,3,2,2,1,3,2,2,1]
[]
[6,4,3,1,1,3,3,1,1,3,2,2,1,4,3,2,1,3,2,2,1,4,2,2,1]
[7,{"$nulls":3},1,{"$nulls":3},1,{"$nulls":3},2,{"$nulls":3},1,{"$nulls":3},1,{"$nulls":3},1]
[8,{"$nulls":3},1,{"$nulls":3},2,{"$nulls":3},2,{"$nulls":3},1,{"$nulls":3},2,{"$nulls":3},1]
[9,{"$nulls":3},1,{"$nulls":3},2,{"$nulls":3},2,{"$nulls":3},2,{"$nulls":3},2,{"$nulls":3},1]
[10,{"$nulls":3},1,{"$nulls":3},2,{"$nulls":3},3,{"$nulls":3},2,{"$nulls":3},3,{"$nulls":3},1]
[]
[]
[null,"Troupes",{"$nulls":5},"Généraux",{"$nulls":4},{"$f":"DGET($A$2:$Y$20,Generator!$A$10&\"-Gal\",H21:H22)","v":0}]
[null,"Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé",null,{"$f":"DGET($A$2:$Y$20,Generator!$A$10&\"-Gal\",I21:I22)","v":0},null,{"$f":"DGET($A$2:$Y$20,Generator!$A$10&\"-Gal\",J21:J22)","v":0},null,{"$f":"DGET($A$2:$Y$20,Generator!$A$10&\"-Gal\",K21:K22)","v":0}]
["Inf",{"$f":"RANDBETWEEN(1,6)","v":3},5,1,1,6,1,{"$f":"RANDBETWEEN(1,10)","v":4},{"$f":"RANDBETWEEN(1,10)","v":5},{"$f":"RANDBETWEEN(1,10)","v":2},{"$f":"RANDBETWEEN(1,10)","v":1},null,{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$10&\"-\"&Armies!$A22,B21:B22)","v":3},{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$10&\"-\"&Armies!$A22,C21:C22)","v":3},{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$10&\"-\"&Armies!$A22,D21:D22)","v":2},{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$10&\"-\"&Armies!$A22,E21:E22)","v":2},{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$10&\"-\"&Armies!$A22,F21:F22)","v":4},{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$10&\"-\"&Armies!$A22,G21:G22)","v":2}]
[null,"Dé","Dé","Dé","Dé","Dé","Dé"]
["Cav",{"$f":"RANDBETWEEN(1,6)","v":3},4,6,1,5,1,{"$nulls":5},{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$10&\"-\"&Armies!$A24,B23:B24)","v":2},{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$10&\"-\"&Armies!$A24,C23:C24)","v":2},{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$10&\"-\"&Armies!$A24,D23:D24)","v":3},{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$10&\"-\"&Armies!$A24,E23:E24)","v":1},{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$10&\"-\"&Armies!$A24,F23:F24)","v":3},{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$10&\"-\"&Armies!$A24,G23:G24)","v":1}]
[null,"Dé","Dé","Dé","Dé","Dé","Dé"]
["Art",{"$f":"RANDBETWEEN(1,6)","v":4},2,5,1,4,2,{"$nulls":5},{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$10&\"-\"&Armies!$A26,B25:B26)","v":1},{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$10&\"-\"&Armies!$A26,C25:C26)","v":1},{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$10&\"-\"&Armies!$A26,D25:D26)","v":1},{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$10&\"-\"&Armies!$A26,E25:E26)","v":0},{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$10&\"-\"&Armies!$A26,F25:F26)","v":1},{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$10&\"-\"&Armies!$A26,G25:G26)","v":1}]
[null,"Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé"]
["Inf",{"$f":"RANDBETWEEN(1,6)","v":1},6,6,6,6,5,{"$f":"RANDBETWEEN(1,10)","v":8},{"$f":"RANDBETWEEN(1,10)","v":9},{"$f":"RANDBETWEEN(1,10)","v":6},{"$f":"RANDBETWEEN(1,10)","v":5},null,{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$17&\"-\"&Armies!$A28,B27:B28)","v":1},{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$17&\"-\"&Armies!$A28,C27:C28)","v":3},{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$17&\"-\"&Armies!$A28,D27:D28)","v":3},{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$17&\"-\"&Armies!$A28,E27:E28)","v":3},{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$17&\"-\"&Armies!$A28,F27:F28)","v":3},{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$17&\"-\"&Armies!$A28,G27:G28)","v":3}]
[null,"Dé","Dé","Dé","Dé","Dé","Dé"]
["Cav",{"$f":"RANDBETWEEN(1,6)","v":4},1,1,4,5,3,{"$nulls":5},{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$17&\"-\"&Armies!$A30,B29:B30)","v":2},{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$17&\"-\"&Armies!$A30,C29:C30)","v":1},{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$17&\"-\"&Armies!$A30,D29:D30)","v":1},{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$17&\"-\"&Armies!$A30,E29:E30)","v":2},{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$17&\"-\"&Armies!$A30,F29:F30)","v":2},{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$17&\"-\"&Armies!$A30,G29:G30)","v":2}]
[null,"Dé","Dé","Dé","Dé","Dé","Dé"]
["Art",{"$f":"RANDBETWEEN(1,6)","v":6},1,6,2,6,6,{"$nulls":5},{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$17&\"-\"&Armies!$A32,B31:B32)","v":1},{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$17&\"-\"&Armies!$A32,C31:C32)","v":0},{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$17&\"-\"&Armies!$A32,D31:D32)","v":1},{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$17&\"-\"&Armies!$A32,E31:E32)","v":0},{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$17&\"-\"&Armies!$A32,F31:F32)","v":1},{"$f":"DGET(Armies!$A$2:$Y$13,Generator!$A$17&\"-\"&Armies!$A32,G31:G32)","v":1}]
[{"$nulls":12},{"$f":"DGET($A$2:$Y$20,Generator!$A$17&\"-Gal\",I27:I28)","v":2},null,{"$f":"DGET($A$2:$Y$20,Generator!$A$17&\"-Gal\",J27:J28)","v":1},null,{"$f":"DGET($A$2:$Y$20,Generator!$A$17&\"-Gal\",K27:K28)","v":1}]
[{"$nulls":12},{"$f":"DGET($A$2:$Y$20,Generator!$A$17&\"-Gal\",H27:H28)","v":2}]

{"sheet":"Units","index":2,"n_rows":60,"n_cols":13,"rows_kept":60,"hidden":true}
["Dé","Fr-Inf","Fr-Cav","GB-Inf","GB-Cav","Pr1-Inf","Pr1-Cav","Aust-Inf","Aust-Cav","Pr2-Inf","Pr2-Cav","Ru-Inf","Ru-Cav"]
[1,"Vieux","Elite","Hanoverian Line","German Horse","Guard/Freikorps*","Guard","Grenadier","Elite Coys","Grenadier","Guard Cavalry","Grenadiers*","Cuirassier"]
[2,"Vieux","Cavalerie légère","Hanoverian Line","German Horse","Grenadiers","Cuirassiers","German Line","Cuirassiers","Grenadier","Cuirassiers","Grenadiers/Line","Cuirassier"]
[3,"Vieux","Cavalerie légère","Hanoverian Line","German Horse","Grenadiers","Cuirassiers","German Line","Cuirassiers","Musketeer","Cuirassiers","Grenadier/Line","Horse Grenadier"]
[4,"Line","Cavalerie légère","Hanoverian Line","German Dragoons","Musketeers","Cuirassiers","German Line","Cuirassiers","Musketeer","Cuirassiers","Line","Dragoon"]
[5,"Line","Cavalerie légère","Hessian Line*","German Dragoons","Musketeers","Cuirassiers","German Line","Cuirassiers","Musketeer","Dragoons","Line","Hussar"]
[6,"Line","Cavalerie légère","Hessian Line*","Guard/Elite***","Musketeers","Dragoons","German Line","Dragoons","Musketeer","Dragoons","Line","Hussar"]
[7,"German","Cavalerie légère","Brunswick Line*","Prussian Dragoons","Musketeers","Dragoons","German Line","Dragoons","Musketeer","Dragoons","Line","Cossacks"]
[8,"Swiss","Cavalerie légère","British Line","Prussian Dragoons","Musketeers","Dragoons","Hungarian","Hussars","Fusilier","Hussar","Line","Cossacks"]
[9,"Grenadiers*","Dragoons","Grenadiers**","British Horse/Dragoon Guard","Musketeers","Hussars","Hungarian","Hussars","Fusilier","Hussar","Obs. Corps Grenadier/Musketeer**","Cossacks"]
[10,"Saxon**","Hussars***","Guard/Elite***","British Dragoons","Fusiliers","Hussars","Grenzer","Saxon","Fusilier/Garrison infantry*","Hussar","Obs. Corps Musketeer","Cossacks"]
[]
[null,"Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé"]
[1,{"$f":"RANDBETWEEN(1,10)","v":7},10,5,3,7,4,10,1,2,6,6,4]
[null,"Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé"]
[2,{"$f":"RANDBETWEEN(1,10)","v":3},8,5,4,2,10,5,8,4,1,2,9]
[null,"Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé"]
[3,{"$f":"RANDBETWEEN(1,10)","v":5},3,4,9,8,3,3,5,4,6,8,7]
[null,"Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé"]
[4,{"$f":"RANDBETWEEN(1,10)","v":8},1,5,3,1,5,2,1,10,8,2,8]
[null,"Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé"]
[5,{"$f":"RANDBETWEEN(1,10)","v":7},6,9,2,3,3,2,3,1,3,1,5]
[null,"Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé"]
[6,{"$f":"RANDBETWEEN(1,10)","v":8},3,5,3,10,9,5,1,2,4,2,7]
[null,"Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé"]
[7,{"$f":"RANDBETWEEN(1,10)","v":4},8,6,4,8,3,9,10,6,1,10,5]
[null,"Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé"]
[8,{"$f":"RANDBETWEEN(1,10)","v":1},9,5,10,9,5,3,2,9,2,7,8]
[null,"Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé"]
[9,{"$f":"RANDBETWEEN(1,10)","v":6},9,3,9,3,9,5,3,8,10,3,7]
[null,"Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé"]
[10,{"$f":"RANDBETWEEN(1,10)","v":6},3,4,6,5,2,9,3,2,10,4,5]
[null,"Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé"]
[11,{"$f":"RANDBETWEEN(1,10)","v":5},6,9,2,6,6,10,8,7,3,2,2]
[null,"Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé"]
[12,{"$f":"RANDBETWEEN(1,10)","v":9},3,6,4,1,2,8,4,8,2,2,6]
[null,"Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé"]
[13,{"$f":"RANDBETWEEN(1,10)","v":9},9,1,4,2,9,2,4,3,6,7,4]
[null,"Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé"]
[14,{"$f":"RANDBETWEEN(1,10)","v":3},3,9,3,5,3,9,10,2,2,6,8]
[null,"Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé"]
[15,{"$f":"RANDBETWEEN(1,10)","v":2},1,5,10,3,1,2,2,10,7,6,8]
[null,"Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé"]
[16,{"$f":"RANDBETWEEN(1,10)","v":2},7,8,10,8,8,1,9,8,3,10,7]
[null,"Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé"]
[17,{"$f":"RANDBETWEEN(1,10)","v":7},9,7,4,7,5,7,6,8,2,2,2]
[null,"Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé"]
[18,{"$f":"RANDBETWEEN(1,10)","v":10},8,6,1,10,9,8,5,7,8,4,9]
[null,"Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé"]
[19,{"$f":"RANDBETWEEN(1,10)","v":7},1,6,2,8,8,10,7,7,5,9,10]
[null,"Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé"]
[20,{"$f":"RANDBETWEEN(1,10)","v":5},1,8,4,10,6,4,9,3,2,2,1]
[null,"Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé"]
[21,{"$f":"RANDBETWEEN(1,10)","v":3},8,8,5,7,5,8,4,10,3,5,7]
[null,"Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé"]
[22,{"$f":"RANDBETWEEN(1,10)","v":7},1,5,1,3,10,7,6,1,8,1,4]
[null,"Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé"]
[23,{"$f":"RANDBETWEEN(1,10)","v":4},1,1,7,7,8,6,7,2,1,8,2]
[null,"Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé","Dé"]
[24,{"$f":"RANDBETWEEN(1,10)","v":3},10,7,10,2,10,4,7,6,3,10,7]

{"sheet":"Comments","index":3,"n_rows":8,"n_cols":3,"rows_kept":8,"hidden":true}
[null,"Nat","Comment"]
["Army","Nat","Comment"]
["French","Fr","* Roll a further D6. On a score of 1 to 3 the unit is Grenadiers de France, on a score of 4 to 6 the unit is Grenadiers Royaux. Only 1 unit of each is allow and so if a 2nd unit is rolled for this will automatically be the other type. If a 3rd unit is rolled for reroll.\n** Every third unit can be an Allied Elite unit.\n*** The first unit rolled for is a Hussar unit. The second unit rolled for is a Mounted Chasseur unit. The third unit is a Guard or Elite unit. If more units are rolled for then start the sequence again, i.e. the 4th unit will be Hussars.\n\nArtillery are always Field Guns"]
["British","GB","* Roll a D6 and on a score of 6 the unit has RF.\n** Can be a unit of any nationality or mixed. Only one unit per nationality is allowed.Choose or dice for which based on the rest of the army. Hessian or Brunswick units roll a D6 and on a score of 5 or 6 the unit has RF.\n*** As above with Grenadiers except Hessian or Brunswick units roll a D6 and on a score of 4, 5 or 6 the unit has RF. If a second unit is rolled for the player gets a Jager (for infantry) or Light Cavalry (for cavalry) unit instead. A 3rd or subsequent unit will be Guard or Elite.\n\nArtillery are always Field Guns"]
["Austrians","Aust","Artillery are always Improved Guns."]
["Prussians (versus Russians)","Pr1","* The first unit rolled is a Guard unit. The second unit rolled is a Freikorps unit. If more units are rolled reroll.\n\nArtillery are always Field Guns"]
["Prussians (versus Austrians)","Pr2","* The first unit rolled is a Garrison Infantry unit. If more units are rolled they are Fusiliers.\n \nArtillery are always Field Guns."]
["Russians","Ru","* The first time this is rolled the unit is all Grenadiers. If there are any subsequent rolls the unit is mixed Grenadier and Line.\n** The first time this is rolled the unit is Obs. Corps Grenadiers. If there are any subsequent rolls the unit is Obs. Corps Musketeers \n\nArtillery are always Large Field Guns."]